﻿CREATE TABLE [sacm].[CatDoctor] (
    [IdEmpresa]         INT            NOT NULL,
    [IdSucursal]        INT            NOT NULL,
    [IdDoctor]          INT            IDENTITY (1, 1) NOT NULL,
    [ApellidoPaterno]   NVARCHAR (250) NULL,
    [ApellidoMaterno]   NVARCHAR (250) NULL,
    [Nombre]            NVARCHAR (250) NULL,
    [CedulaProfesional] VARCHAR (50)   NULL,
    [RFC]               VARCHAR (20)   NULL,
    [DomicilioFiscal]   VARCHAR (8000) NULL,
    [Telefono]          VARCHAR (30)   NULL,
    [FechaMod]          DATETIME       NULL,
    [IpMod]             VARCHAR (15)   NULL,
    [IdUsuarioMod]      INT            NULL,
    PRIMARY KEY CLUSTERED ([IdEmpresa] ASC, [IdSucursal] ASC, [IdDoctor] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);





